UCSF

Parameters Provided:

name.synonym = 1-Ethoxymethyl-2-methoxybenzene; 2-Methoxybenzyl ethyl ether; BRN 2087623; Benzene, 1-(ethoxymethyl)-2-methoxy-; EINECS 265-301-3; Ether, ethyl o-methoxybenzyl; Ethyl 2-methoxybenzyl ether; Ethyl o-methoxybenzyl ether; LS-30328; o-(Ethoxymethyl)anisole; o
filter.purchasability = all
page.num = 1

Structural Results Found: (before additional filtering)

SQL Query Was

SELECT DISTINCT(ci.sub_id_fk) AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id INNER JOIN synonym AS syn ON (ci.cat_id_fk=syn.cat_fk AND ci.supplier_code=syn.supplier_code) INNER JOIN field AS f ON syn.field_fk=f.field_id  WHERE c.free = 1 AND syn.synonym IS NOT NULL AND syn.synonym LIKE '1-Ethoxymethyl-2-methoxybenzene; 2-Methoxybenzyl ethyl ether; BRN 2087623; Benzene, 1-(ethoxymethyl)-2-methoxy-; EINECS 265-301-3; Ether, ethyl o-methoxybenzyl; Ethyl 2-methoxybenzyl ether; Ethyl o-methoxybenzyl ether; LS-30328; o-(Ethoxymethyl)anisole; o' AND f.ftype IN (3,7,11,12,14) AND ci.sub_id_fk IN (SELECT ci.sub_id_fk AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id  WHERE c.free = 1   )    LIMIT 50

Permalink

//zinc12.docking.org/results/combination?name.synonym=1-Ethoxymethyl-2-methoxybenzene%3B+2-Methoxybenzyl+ethyl+ether%3B+BRN+2087623%3B+Benzene%2C+1-%28ethoxymethyl%29-2-methoxy-%3B+EINECS+265-301-3%3B+Ether%2C+ethyl+o-methoxybenzyl%3B+Ethyl+2-methoxybenzyl+ether%3B+Ethyl+o-methoxybenzyl+ether%3B+LS-30328%3B+o-%28Ethoxymethyl%29anisole%3B+o&filter.purchasability=all

Embed Link to Results